在使用数据泵进行模式级别导入导出时,导出成功后进行数据导入。出现报错:
![](https://img-blog.csdnimg.cn/20200723164305377.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMjUwMzMz,size_16,color_FFFFFF,t_70)
可以看到存储过程对象F_NUM编译报错。
那么首先查看无效对象。
SYS@proe>col object_name for a30;
SYS@proe>select owner,object_name,object_type,status
from dba_objects
where status !='VALID'
and owner not in ('SYS','SYSTEM') 2 3 4 ;
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200723164358864.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMjUwMzMz,size_16,color_FFFFFF,t_70)
对这个无效对象执行编译。
SYS@proe>alter procedure new_scott.F_NUM compile;
Warning: Procedure altered with compilation errors.
编译无效对象方法: view: alter view view_name compile; function: alter function function_name compile; procedure: alter procedure procedure_name compile;
发现编译是不成功的,使用show error进行判断
SYS@proe>show errors procedure new_scott.F_NUM;
Errors for PROCEDURE NEW_SCOTT.F_NUM:
LINE/COL ERROR
-------- ------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
2/11 PLS-00201: identifier 'EMPLOYEES.EMPLOYEE_ID' must be declared
|